------------------------------------------------------------------------------------------------------------------------------------------
      name:  <unnamed>
       log:  E:\REStat_MS14767_Vol96(2)\Data preparation Compustat segment\1_cleancompustat.log
  log type:  text
 opened on:  18 Dec 2014, 18:04:14

. *-----------------------------------------------------------------
. 
. set mem 700m

. set mat 2000

. 
. **********************************
. * This file is supposed to solve the problem with double entries 
. * in the compustat database. Mainly canadian firms are affected
. * by this procedure. Which entry is to be kept depends on the information
. * the entry may deliver. 
. * The resulting file clean_compustat_master contains all
. * firms but no doubles.
. * The correction of sales is not included.
. **************************************
. 
. use "raw data/master_compustat_all_countries.dta"

. 
. order ticker year CUSIP name sales employees

. so CUSIP year

. 
. count if CUSIP==CUSIP[_n-1] & year==year[_n-1]
 5236

.  *5236
. 
. 
. *********************************************
. * Tickers with a "3" in front mean, that those
. * titles are only traded over the counter OR that
. * those firms were delisted from NASDAQ. 
. * Tickers with a "." in the end mean, that those
. * tickers might belong to different firms in Canada
. * and US and therefor the Canadian firm gets the "."
. * OR that one firm is active and the other one is only 
. * available for research.
. * Tricky issue!
. **************************************************
. 
. gen droplater=.
(340830 missing values generated)

. replace droplater=1 if ticker=="ADY." /* ADB SYSTEMS INTL LTD, surviving ticker: 3ADBYF */
(14 real changes made)

. replace droplater=1 if ticker=="ATY." /* ATI TECHNOLOGIES INC, surviving ticker: ATYT */
(14 real changes made)

. replace droplater=1 if ticker=="ABZ" /* ABER DIAMOND CORP, surviving ticker: ABER */
(14 real changes made)

. replace droplater=1 if ticker=="A." /* ABITIBI CONSOLIDATED INC, surviving ticker: ABY */
(14 real changes made)

. replace droplater=1 if ticker=="ACE.B" /* ACE AVIATION HOLDINGS INC, surviving ticker: ACEBF */
(14 real changes made)

. replace droplater=1 if ticker=="AHX" /* ADHEREX TECHNOLOGIES INC, surviving ticker: ADH */
(14 real changes made)

. replace droplater=1 if ticker=="AAV" /* ADVANTAGE ENERGY INCOME FUND, surviving ticker: AVN.U */
(14 real changes made)

. replace droplater=1 if ticker=="AEZS" /* AETERNA ZENTARIS INC, surviving ticker: AEZ. */
(14 real changes made)

. replace droplater=1 if ticker=="AEM." /* AGNICO EAGLE MINES LTD, surviving ticker: AEM */
(14 real changes made)

. replace droplater=1 if ticker=="AGU." /* AGRIUM INC, surviving ticker: AGU */
(14 real changes made)

. replace droplater=1 if ticker=="AGT." /* AIMGLOBAL TECHNOLOGIES INC, surviving ticker: AIMG */
(14 real changes made)

. replace droplater=1 if ticker=="AL." /* ALCAN INC, surviving ticker: AL */
(14 real changes made)

. replace droplater=1 if ticker=="0192B" /* ALDERWOODS GROUP INC, surviving ticker: AWGI */
(14 real changes made)

. replace droplater=1 if ticker=="0236B" /* ALGOMA STEEL INC, surviving ticker: AGA */
(14 real changes made)

. replace droplater=1 if ticker=="AAC.NV.B" /* ALLIANCE ATLANTIS COMM -CL B, surviving ticker: AACB */
(14 real changes made)

. replace droplater=1 if ticker=="AAU" /* ALMADEN MINERALS LTD, surviving ticker: AAM. */
(14 real changes made)

. replace droplater=1 if ticker=="3251B" /* ALTAIR NANOTECHNOLOGIES INC, surviving ticker: ALTI */
(14 real changes made)

. replace droplater=1 if ticker=="ANPI" /* ANGIOTECH PHARMACEUTICALS, surviving ticker: ANP. */
(14 real changes made)

. replace droplater=1 if ticker=="ASW." /* ANGLO SWISS RESOURCES INC, surviving ticker: 3ASWRF */
(14 real changes made)

. replace droplater=1 if ticker=="AOM." /* ANORMED INC, surviving ticker: AOM */
(14 real changes made)

. replace droplater=1 if ticker=="ARQ" /* ANOORAQ RESOURCES CORP, surviving ticker: ANO */
(14 real changes made)

. replace droplater=1 if ticker=="APG" /* APOLLO GOLD CORP, surviving ticker: AGT */
(14 real changes made)

. replace droplater=1 if ticker=="APQ." /* ASIA PACIFIC RESOURCES LTD, surviving ticker: APQCF */
(14 real changes made)

. replace droplater=1 if ticker=="ASR." /* ASPEN GROUP RESOURCES CORP, surviving ticker: ASRPF */
(14 real changes made)

. replace droplater=1 if ticker=="ASV" /* ASPREVA PHARMACEUTICALS CORP, surviving ticker: ASPV */
(14 real changes made)

. replace droplater=1 if ticker=="AZK" /* AURIZON MINES LTD, surviving ticker: ARZ. */
(14 real changes made)

. replace droplater=1 if ticker=="APX." /* AUSTRAL PACIFIC ENERGY LTD, surviving ticker: AEN */
(14 real changes made)

. replace droplater=1 if ticker=="ASM." /* AVINO SILVER&GOLD MINES LTD, surviving ticker: 3ASGMF */
(14 real changes made)

. replace droplater=1 if ticker=="AZC." /* AZCO MINING INC/DE, surviving ticker: AZMN */
(14 real changes made)

. replace droplater=1 if ticker=="AXP." /* AXCAN PHARMA INC, surviving ticker: AXCA */
(14 real changes made)

. replace droplater=1 if ticker=="BCE." /* BCE INC, surviving ticker: BCE */
(14 real changes made)

. replace droplater=1 if ticker=="BPR." /* BPI INDUSTRIES INC, surviving ticker: BPG */
(14 real changes made)

. replace droplater=1 if ticker=="BLD." /* BALLARD POWER SYSTEMS INC, surviving ticker: BLDP */
(14 real changes made)

. replace droplater=1 if ticker=="BAA." /* BANRO CORP, surviving ticker: BAA */
(14 real changes made)

. replace droplater=1 if ticker=="ABX." /* BARRICK GOLD CORP, surviving ticker: ABX */
(14 real changes made)

. replace droplater=1 if ticker=="BTI." /* BATTERY TECHNOLOGIES INC, surviving ticker: BTIOQ */
(14 real changes made)

. replace droplater=1 if ticker=="BI." /* BELL CANADA INTL INC, surviving ticker: BCICF */
(14 real changes made)

. replace droplater=1 if ticker=="BCE1." /* BELL CANADA, surviving ticker: BCE1 */
(14 real changes made)

. replace droplater=1 if ticker=="BGO." /* BEMA GOLD CORP, surviving ticker: BGO */
(14 real changes made)

. replace droplater=1 if ticker=="BEL" /* BENNETT ENVIRONMENTAL INC, surviving ticker: BEV. */
(14 real changes made)

. replace droplater=1 if ticker=="BR.U" /* BIG ROCK BREWERY INCOME TR, surviving ticker: BRBMF */
(14 real changes made)

. replace droplater=1 if ticker=="7520B" /* BIOJECT MEDICAL TECHNOL, surviving ticker: BJCT */
(14 real changes made)

. replace droplater=1 if ticker=="BMD." /* BIRCH MOUNTAIN RESOURCES LTD, surviving ticker: BMD */
(14 real changes made)

. replace droplater=1 if ticker=="BVF." /* BIOVAIL CORP, surviving ticker: BVF */
(14 real changes made)

. replace droplater=1 if ticker=="BRA" /* BIOMIRA INC, surviving ticker: BIOM */
(14 real changes made)

. replace droplater=1 if ticker=="BMM.U" /* BLACK MOUNTAIN CAPITAL CORP, surviving ticker: 3BMMUF */
(14 real changes made)

. replace droplater=1 if ticker=="BOWFF" /* BOARDWALK REAL ESTATE TRUST, survivin ticker: BEI.U */
(14 real changes made)

. replace droplater=1 if ticker=="BOW1" /* BOWATER PULP & PAPER, surviving ricker: BOW1. */
(14 real changes made)

. replace droplater=1 if ticker=="BZO" /* BRAZAURO RESOURCES CORP, surviving ticker: BZOFF */
(14 real changes made)

. replace droplater=1 if ticker=="BWR." /* BREAKWATER RESOURCES LTD, surviving ticker: 3BWLRF */
(14 real changes made)

. replace droplater=1 if ticker=="GGG.Z" /* BRONX VENTURES INC, surviving ticker: 3BRXVF */
(14 real changes made)

. replace droplater=1 if ticker=="BAM.LV.A" /* BROOKFIELD ASSET MANAGEMENT, surviving ticker: BAM */
(14 real changes made)

. replace droplater=1 if ticker=="BPO" /* BROOKFIELD PROPERTIES CORP, surviving ticker: BPO. */
(14 real changes made)

. replace droplater=1 if ticker=="CGT" /* CAE INC, surviving ticker: CAE. */
(14 real changes made)

. replace droplater=1 if ticker=="CFK" /* CE FRANKLIN LTD, surviving ticker: CFT. */
(14 real changes made)

. replace droplater=1 if ticker=="FLY.SV.A" /* CHC HELICOPTER CORP  -CL A, surviving ticker: FLI */
(14 real changes made)

. replace droplater=1 if ticker=="HCH." /* MERRILL LYNCH CANADA CP HLDR, surviving ticker: HCH */
(14 real changes made)

. replace droplater=1 if ticker=="CBJ." /* CAMBIOR INC, surviving ticker: CBJ */
(14 real changes made)

. replace droplater=1 if ticker=="TTV." /* CABLETEL COMMUNICATIONS CORP, surviving ticker: CCMTF */
(14 real changes made)

. replace droplater=1 if ticker=="CCO." /* CAMECO CORP, surviving ticker: CCJ */
(14 real changes made)

. replace droplater=1 if ticker=="CCH." /* CAMPBELL RESOURCES INC, surviving ticker: 3CBLRF */
(14 real changes made)

. replace droplater=1 if ticker=="CL." /* CANADA LIFE FINANCIAL CORP, surviving ticker: CLU */
(14 real changes made)

. replace droplater=1 if ticker=="CSW" /* CANADA SOUTHERN PETROLEUM, surviving ticker: CSPLF */
(14 real changes made)

. replace droplater=1 if ticker=="CNR." /* CANADIAN NATIONAL RAILWAY CO, surviving ticker: CNI */
(14 real changes made)

. replace droplater=1 if ticker=="CNQ" /* CANADIAN NATURAL RESOURCES, surviving ticker: CNQ. */
(14 real changes made)

. replace droplater=1 if ticker=="CP." /* CANADIAN PACIFIC RAILWAY LTD, surviving ticker: CP */
(14 real changes made)

. replace droplater=1 if ticker=="SNG." /* CANADIAN SUPERIOR ENERGY INC, surviving ticker: SNG */
(14 real changes made)

. replace droplater=1 if ticker=="CVV." /* CANALASKA VENTURES LTD, surviving ticker: 3CVVLF */
(14 real changes made)

. replace droplater=1 if ticker=="CCM." /* CANARC RESOURCE CORP, surviving ticker: 3CRCUF */
(14 real changes made)

. replace droplater=1 if ticker=="CGS.NV" /* CANWEST GLOBAL COM  -NVTG, surviving ticker: CWG */
(14 real changes made)

. replace droplater=1 if ticker=="CDU" /* CARDERO RESOURCE CORP, surviving ticker: CDY */
(14 real changes made)

. replace droplater=1 if ticker=="CRME" /* CARDIOME PHARMA CORP, surviving ticker: COM */
(14 real changes made)

. replace droplater=1 if ticker=="CLS.SV" /* CELESTICA INC, surviving ticker: CLS */
(14 real changes made)

. replace droplater=1 if ticker=="CEF.NV.A" /* CENTRAL FUND CANADA  -CL A, surviving ticker: CEF */
(14 real changes made)

. replace droplater=1 if ticker=="3250B" /* CENTRAL MINERA CORP, surviving ticker: 3CENMF */
(14 real changes made)

. replace droplater=1 if ticker=="CERTF" /* CERTICOM CORP, surviving ticker: CIC. */
(14 real changes made)

. replace droplater=1 if ticker=="CC." /* CHAI NA TA CORP, surviving ticker: 3CCCFF */
(14 real changes made)

. replace droplater=1 if ticker=="CRW." /* CINRAM INTERNATIONAL INC, surviving ticker: CNRMF */
(14 real changes made)

. replace droplater=1 if ticker=="CTM." /* CINTECH SOLUTIONS INC, surviving ticker: 3CMGFF */
(14 real changes made)

. replace droplater=1 if ticker=="CRJ" /* CLAUDE RESOURCES INC, surviving ticker: CGR */
(14 real changes made)

. replace droplater=1 if ticker=="CLV." /* CLEARLY CDN BEVERAGE CP, surviving ticker: 3CCBEF */
(14 real changes made)

. replace droplater=1 if ticker=="CDM" /* COEUR D'ALENE MINES CORP, surviving ticker: CDE */
(14 real changes made)

. replace droplater=1 if ticker=="CSN." /* COGNOS INC, surviving ticker: COGN */
(14 real changes made)

. replace droplater=1 if ticker=="3ZCCCF" /* COMMERCIAL CONSOLIDATORS CP, surviving ticker: CCZ.1 */
(14 real changes made)

. replace droplater=1 if ticker=="CMT." /* COMPTON PETROLEUM CORP, surviving ticker: CMZ */
(14 real changes made)

. replace droplater=1 if ticker=="CNY." /* CONIAGAS RESOURCES LTD, surviving ticker: 3COIGE */
(14 real changes made)

. replace droplater=1 if ticker=="CMC." /* CONSOLIDATED MERCANTILE INC, surviving ticker: CSLMF */
(14 real changes made)

. replace droplater=1 if ticker=="3CGREF" /* CORAL GOLD RESOURCES LTD, surviving ticker: CGR. */
(14 real changes made)

. replace droplater=1 if ticker=="CJR.NV.B" /* CORUS ENTERTAINMENT INC, surviving ticker: CJR */
(14 real changes made)

. replace droplater=1 if ticker=="BCB" /* COTT CORP QUE, surviving ticker: COT */
(14 real changes made)

. replace droplater=1 if ticker=="CXS." /* COUNSEL CORP, surviving ticker: CXSNF */
(14 real changes made)

. replace droplater=1 if ticker=="CRY." /* CRYPTOLOGIC INC, surviving ticker: CRYP */
(14 real changes made)

. replace droplater=1 if ticker=="KRY." /* CRYSTALLEX INTERNATIONAL CP, surviving ticker: KRY */
(14 real changes made)

. replace droplater=1 if ticker=="CLG" /* CUMBERLAND RESOURCES LTD, surviving ticker: CLG. */
(14 real changes made)

. replace droplater=1 if ticker=="0604B" /* CURRENT TECHNOLOGY CORP, surviving ticker: 3CRTCF */
(14 real changes made)

. replace droplater=1 if ticker=="CQC" /* CUSAC GOLD MINES LTD, surviving ticker: 3CUSIF */
(14 real changes made)

. replace droplater=1 if ticker=="2158B" /* DALECO RESOURCES CORP, surviving ticker: 3DLOV */
(14 real changes made)

. replace droplater=1 if ticker=="DTV." /* DATAWAVE SYSTEMS INC, surviving ticker: 3DWVS */
(14 real changes made)

. replace droplater=1 if ticker=="DMC." /* DATAMIRROR CORP, surviving ticker: DMCX */
(14 real changes made)

. replace droplater=1 if ticker=="DTGLF" /* DATEC GROUP LTD, surviving ticker: DGL. */
(14 real changes made)

. replace droplater=1 if ticker=="DTL" /* DECTRON INTERNATIONALE INC, surviving ticker: DECT */
(14 real changes made)

. replace droplater=1 if ticker=="DNR." /* DENBURY RESOURCES INC, surviving ticker: DNR */
(14 real changes made)

. replace droplater=1 if ticker=="DSG." /* DESCARTES SYSTEMS GROUP INC, surviving ticker: DSGX */
(14 real changes made)

. replace droplater=1 if ticker=="DSM." /* DESERT SUN MINING CORP, surviving ticker: DEZ */
(14 real changes made)

. replace droplater=1 if ticker=="8608B" /* DIAMANT ART CORP, surviving ticker: 3DIAAF */
(14 real changes made)

. replace droplater=1 if ticker=="9142B" /* DIVERSINET CORP, surviving ticker: 3DVNTF */
(14 real changes made)

. replace droplater=1 if ticker=="DTC." /* DOMTAR INC, surviving ticker: DTC */
(14 real changes made)

. replace droplater=1 if ticker=="DII.SV" /* DOREL INDUSTRIES INC, surviving ticker: DIIB */
(14 real changes made)

. replace droplater=1 if ticker=="DAX" /* DRAXIS HEALTH INC, surviving ticker: DRAX */
(14 real changes made)

. replace droplater=1 if ticker=="3248B" /* DUSA PHARMACEUTICALS INC, surviving ticker: DUSA */
(14 real changes made)

. replace droplater=1 if ticker=="DOL." /* DYNAMIC OIL & GAS INC, surviving ticker: DYOLF */
(14 real changes made)

. replace droplater=1 if ticker=="9624B" /* DYNAMOTIVE ENERGY SYS CORP, surviving ticker: 3DYMTF */
(14 real changes made)

. replace droplater=1 if ticker=="9198B" /* E DIGITAL CORP, surviving ticker: 3EDIG */
(14 real changes made)

. replace droplater=1 if ticker=="EGC" /* EG CAPITAL INC, surviving ticker: EGCFF */
(14 real changes made)

. replace droplater=1 if ticker=="EGO" /* ELDORADO GOLD CORP, surviving ticker: ELD */
(14 real changes made)

. replace droplater=1 if ticker=="8332B" /* ELEPHANT & CASTLE GROUP INC, surviving ticker: 3PUBSF */
(14 real changes made)

. replace droplater=1 if ticker=="ECA." /* ENCANA CORP, surviving ticker: ECA */
(14 real changes made)

. replace droplater=1 if ticker=="ENB." /* ENBRIDGE INC, surviving ticker: ENB */
(14 real changes made)

. replace droplater=1 if ticker=="ERF.U" /* ENERPLUS RESOURCES FUND, surviving ticker: ERF */
(14 real changes made)

. replace droplater=1 if ticker=="ENT.U" /* ENTERRA ENERGY TRUST, surviving ticker: EENC */
(14 real changes made)

. replace droplater=1 if ticker=="ETG." /* ENTREE GOLD INC, surviving ticker: EGI */
(14 real changes made)

. replace droplater=1 if ticker=="ECG" /* ENVOY COMMUNICATIONS GRP INC, surviving ticker: ECGI */
(14 real changes made)

. replace droplater=1 if ticker=="EEE.U" /* ESPRIT ENERGY TRUST, surviving ticker: EEEBF */
(14 real changes made)

. replace droplater=1 if ticker=="EZM" /* EUROZINC MINING CORP, surviving ticker: EZM. */
(14 real changes made)

. replace droplater=1 if ticker=="EXF.SV" /* EXFO ELECTRO OPTICAL ENGR, surviving ticker: EXFO */
(14 real changes made)

. replace droplater=1 if ticker=="EXE.SV" /* EXTENDICARE INC  -SVTG, surviving ticker: EXE */
(14 real changes made)

. replace droplater=1 if ticker=="TPC.Z" /* FEC RESOURCES INC, surviving ticker: 3FECOF */
(14 real changes made)

. replace droplater=1 if ticker=="FNX." /* FNX MINING CO INC, surviving ticker: FNX */
(14 real changes made)

. replace droplater=1 if ticker=="FFH" /* FAIRFAX FINANCIAL HOLDINGS, surviving ticker: FFH.SV */
(14 real changes made)

. replace droplater=1 if ticker=="FHR." /* FAIRMONT HOTELS RESORTS INC, surviving ticker: FHR */
(14 real changes made)

. replace droplater=1 if ticker=="FAL.LV" /* FALCONBRIDGE LTD, surviving ticker: FAL */
(14 real changes made)

. replace droplater=1 if ticker=="FTM" /* FANTOM TECHNOLOGIES INC, surviving ticker: FTMTQ */
(14 real changes made)

. replace droplater=1 if ticker=="FSV.SV" /* FIRSTSERVICE CORP  -SVTG, surviving ticker: FSRV */
(14 real changes made)

. replace droplater=1 if ticker=="FMI." /* FORBES MEDI-TECH INC, surviving ticker: FMTI */
(14 real changes made)

. replace droplater=1 if ticker=="FDG.U" /* FORDING CANADIAN COAL TRUST, surviving ticker: FDG */
(14 real changes made)

. replace droplater=1 if ticker=="FSH.SV" /* FOUR SEASONS HOTELS -LTD VTG, surviving ticker: FS */
(14 real changes made)

. replace droplater=1 if ticker=="FRG." /* FRONTEER DEVELOPMENT GRP INC, surviving ticker: FRG */
(14 real changes made)

. replace droplater=1 if ticker=="GSI." /* GSI GROUP INC, surviving ticker: GSIG */
(14 real changes made)

. replace droplater=1 if ticker=="GRS" /* GAMMON LAKE RESOURCES INC, surviving ticker: GAM. */
(14 real changes made)

. replace droplater=1 if ticker=="YGA" /* GASTAR EXPLORATION LTD, surviving ticker: GST */
(14 real changes made)

. replace droplater=1 if ticker=="GAC." /* GEAC COMPUTER CORP LTD, surviving ticker: GEAC */
(14 real changes made)

. replace droplater=1 if ticker=="GNA." /* GERDAU AMERISTEEL CORP, surviving ticker: GNA */
(14 real changes made)

. replace droplater=1 if ticker=="GIL." /* GILDAN ACTIVEWEAR INC, surviving ticker: GIL */
(14 real changes made)

. replace droplater=1 if ticker=="GLG." /* GLAMIS GOLD LTD, surviving ticker: GLG. */
(14 real changes made)

. replace droplater=1 if ticker=="GGG." /* GLENCAIRN GOLD CORP, surviving ticker: GLE */
(14 real changes made)

. replace droplater=1 if ticker=="GGB.Z" /* GLOBAL LT TELECOMMUNICATIONS, ticker: GBTI */
(14 real changes made)

. replace droplater=1 if ticker=="CLP." /* GLOBETECH VENTURES CORP, surviving ticker: 3GTVCF */
(14 real changes made)

. replace droplater=1 if ticker=="G." /* GOLDCORP INC, surviving ticker: GG */
(14 real changes made)

. replace droplater=1 if ticker=="GGR." /* GOLDEN GOOSE RESOURCE, surviving ticker: 3GGOSF */
(14 real changes made)

. replace droplater=1 if ticker=="GSC." /* GOLDEN STAR RESOURCES LTD, surviving ticker: GSS */
(14 real changes made)

. replace droplater=1 if ticker=="GNC." /* GORAN CAPITAL INC, surviving ticker: GNCN */
(14 real changes made)

. replace droplater=1 if ticker=="7637B" /* GRANDETEL TECHNOLOGIES INC, surviving ticker: GTTIF */
(14 real changes made)

. replace droplater=1 if ticker=="GBG" /* GREAT BASIN GOLD LTD, surviving ticker: GBN */
(14 real changes made)

. replace droplater=1 if ticker=="GIB" /* CGI GROUP INC  -CL A, surviving ticker: GIB.SV.A */
(14 real changes made)

. replace droplater=1 if ticker=="HTE.U" /* HARVEST ENERGY TRUST, surviving ticker: HTE */
(14 real changes made)

. replace droplater=1 if ticker=="3269B" /* HEALTHTRAC INC, surviving ticker: HTAC */
(14 real changes made)

. replace droplater=1 if ticker=="HMSLQ" /* HEMOSOL CORP, surviving ticker: HML. */
(14 real changes made)

. replace droplater=1 if ticker=="HLG.C" /*HOLLINGER INC, surviving ticker: HLGAF */
(14 real changes made)

. replace droplater=1 if ticker=="HBG" /* HUB INTERNATIONAL LTD, surviving ticker: HBG. */
(14 real changes made)

. replace droplater=1 if ticker=="HUM." /* HUMMINGBIRD LTD, surviving ticker: HUMC */
(14 real changes made)

. replace droplater=1 if ticker=="HYG" /* HYDROGENICS CORP, surviving ticker: HYGA */
(14 real changes made)

. replace droplater=1 if ticker=="IMR" /* IMA EXPLORATION INC, surviving ticker: IMR. */
(14 real changes made)

. replace droplater=1 if ticker=="IMG." /* IAMGOLD CORP, surviving ticker: IAG */
(14 real changes made)

. replace droplater=1 if ticker=="IMX." /* IMAX CORP, surviving ticker: IMAX */
(14 real changes made)

. replace droplater=1 if ticker=="IGP" /* IMPERIAL GINSENG PRODS LTD, surviving ticker: IGPFF */
(14 real changes made)

. replace droplater=1 if ticker=="IMO." /* IMPERIAL OIL LTD, surviving ticker: IMO */
(14 real changes made)

. replace droplater=1 if ticker=="N." /* INCO LTD, surviving ticker: N */
(14 real changes made)

. replace droplater=1 if ticker=="INP" /* INFOCORP COMPUTER SOLUTIONS, surviving ticker: IFCSF */
(14 real changes made)

. replace droplater=1 if ticker=="INO" /* INOVIO BIOMEDICAL CORP, surviving ticker: GEB. */
(14 real changes made)

. replace droplater=1 if ticker=="3IBTGF" /* INTERNATIONAL BARRIER TECH I, surviving ticker: IBH */
(14 real changes made)

. replace droplater=1 if ticker=="7116B" /* INTL GEMINI TECH INC, surviving ticker: 6971B */
(14 real changes made)

. replace droplater=1 if ticker=="ITW." /* INTRAWEST CORP, surviving ticker: IDR */
(14 real changes made)

. replace droplater=1 if ticker=="ITP." /* INTERTAPE POLYMER GROUP INC, surviving ticker: ITP */
(14 real changes made)

. replace droplater=1 if ticker=="IOL" /* INTEROIL CORP, surviving ticker: IOC */
(14 real changes made)

. replace droplater=1 if ticker=="IPS." /* IPSCO INC, surviving ticker: IPS */
(14 real changes made)

. replace droplater=1 if ticker=="ITX" /* ITERATION ENERGY LTD, surviving ticker: ITXFF */
(14 real changes made)

. replace droplater=1 if ticker=="IE" /* IVANHOE ENERGY INC, surviving ticker: IVAN */
(14 real changes made)

. replace droplater=1 if ticker=="IVN" /* IVANHOE MINES LTD, surviving ticker: IVN. */
(14 real changes made)

. replace droplater=1 if ticker=="JCT." /* JEWETT-CAMERON TRADING CO, surviving ticker: JCTCF */
(14 real changes made)

. replace droplater=1 if ticker=="JSD" /* JONES SODA CO, surviving ticker: JSDA */
(14 real changes made)

. replace droplater=1 if ticker=="MXB.U" /* KHD HUMBOLDT WEDAG INTL LTD, surviving ticker: KHDH */
(14 real changes made)

. replace droplater=1 if ticker=="KBR" /* KIMBER RESOURCES INC surviving ticker: KBX */
(14 real changes made)

. replace droplater=1 if ticker=="K." /* KINROSS GOLD CORP, surviving ticker: KGC */
(14 real changes made)

. replace droplater=1 if ticker=="KFS" /* KINGSWAY FINANCIAL SVCS INC, surviving ticker: KFS. */
(14 real changes made)

. replace droplater=1 if ticker=="LMZ." /* LMS MEDICAL SYSTEMS INC, surviving ticker: LMZ */
(14 real changes made)

. replace droplater=1 if ticker=="KRK" /* LML PAYMENT SYSTEMS INC, surviving ticker: LMLP */
(14 real changes made)

. replace droplater=1 if ticker=="BUS." /* LAIDLAW INTERNATIONAL INC, surviving ticker: LI */
(14 real changes made)

. replace droplater=1 if ticker=="LAG" /* LAURION GOLD INC, surviving ticker: LAGFF */
(14 real changes made)

. replace droplater=1 if ticker=="9008B" /* LEADING BRANDS INC, surviving ticker: LBIX */
(14 real changes made)

. replace droplater=1 if ticker=="LVN" /* LEVON RESOURCES LTD, surviving ticker: 3LVNVE */
(14 real changes made)

. replace droplater=1 if ticker=="LIM" /* LIONORE MINING INTL LTD, surviving ticker: 3LMGGF */
(14 real changes made)

. replace droplater=1 if ticker=="LGF." /* LIONS GATE ENTMT CORP, surviving ticker: LGF */
(14 real changes made)

. replace droplater=1 if ticker=="LQW" /* LIQUIDATION WORLD INC, surviving ticker: LIQWF */
(14 real changes made)

. replace droplater=1 if ticker=="LOR." /* LORUS THERAPEUTICS INC, surviving ticker: LRP */
(14 real changes made)

. replace droplater=1 if ticker=="MDZ.SV.A" /* MDC PARTNERS INC, surviving ticker: MDCA */
(14 real changes made)

. replace droplater=1 if ticker=="MDZ" /* MDS INC, surviving ticker: MDS. */
(14 real changes made)

. replace droplater=1 if ticker=="MIM.SV.A" /* MI DEVELOPMENTS INC, surviving ticker: MIM */
(14 real changes made)

. replace droplater=1 if ticker=="MCZ." /* MAD CATZ INTERACTIVE INC, surviving ticker: MCZ */
(14 real changes made)

. replace droplater=1 if ticker=="3MMRSF" /* MADISON MINERALS INC, surviving ticker: MMR. */
(14 real changes made)

. replace droplater=1 if ticker=="MEC.SV.A" /* MAGNA ENTERTAINMENT CORP, surviving ticker: MECA */
(14 real changes made)

. replace droplater=1 if ticker=="MG.SV.A" /* MAGNA INTERNATIONAL  -CL A, surviving ticker: MGA */
(14 real changes made)

. replace droplater=1 if ticker=="8627B" /* MAMMA.COM INC, surviving ticker: MAMA */
(14 real changes made)

. replace droplater=1 if ticker=="MFC." /* MANULIFE FINANCIAL CORP, surviving ticker: MFC */
(14 real changes made)

. replace droplater=1 if ticker=="3393B" /* MED-EMERG INTERNATIONAL INC, surviving ticker: 3MDER */
(14 real changes made)

. replace droplater=1 if ticker=="MPH." /* MEDICURE INC, surviving ticker: MCU */
(14 real changes made)

. replace droplater=1 if ticker=="MNG." /* MERIDIAN GOLD INC, surviving ticker: MDG */
(14 real changes made)

. replace droplater=1 if ticker=="MR." /* METALLICA RESOURCES INC, surviving ticker: MRB */
(14 real changes made)

. replace droplater=1 if ticker=="MX." /* METHANEX CORP, surviving ticker: MEOH */
(14 real changes made)

. replace droplater=1 if ticker=="0455B" /* MICROMEM TECHNOLOGIES INC, surviving ticker: 3MMTIF */
(14 real changes made)

. replace droplater=1 if ticker=="MGI." /* MIGENIX INC, surviving ticker: 3MGIFF */
(14 real changes made)

. replace droplater=1 if ticker=="MMM." /* MINCO MINING & METALS CORP, surviving ticker: MMK */
(14 real changes made)

. replace droplater=1 if ticker=="MFN" /* MINEFINDERS CORP LTD, surviving ticker: MFL. */
(14 real changes made)

. replace droplater=1 if ticker=="MAE" /* MIRAMAR MINING CORP, surviving ticker: MNG */
(14 real changes made)

. replace droplater=1 if ticker=="MNT." /* MIRTRONICS INC, surviving ticker: 3MNTCE */
(14 real changes made)

. replace droplater=1 if ticker=="MPV." /* MOUNTAIN PROVINCE DIAMONDS, surviving ticker: MDM */
(14 real changes made)

. replace droplater=1 if ticker=="NBS." /* NBS TECHNOLOGIES INC, surviving ticker: NBSFF */
(14 real changes made)

. replace droplater=1 if ticker=="7518B" /* NGAS RESOURCES INC, surviving ticker: NGAS */
(14 real changes made)

. replace droplater=1 if ticker=="NQL." /* NQL ENERGY SERVICES INC, surviving ticker: 3NQDRF */
(14 real changes made)

. replace droplater=1 if ticker=="NRM" /* NEUROCHEM INC, surviving ticker: NRMX */
(14 real changes made)

. replace droplater=1 if ticker=="NEV." /* NEVADA STAR RESOURCE CORP, surviving ticker: 3NVSRF */
(14 real changes made)

. replace droplater=1 if ticker=="NSU" /* NEVSUN RESOURCES LTD, surviving ticker: NSU. */
(14 real changes made)

. replace droplater=1 if ticker=="NGD." /* NEW GOLD INC, surviving ticker: NGD */
(14 real changes made)

. replace droplater=1 if ticker=="NXY." /* NEXEN INC, surviving ticker: NXY */
(14 real changes made)

. replace droplater=1 if ticker=="3636B" /* NICHOLAS FINANCIAL INC, surviving ticker: NICK */
(14 real changes made)

. replace droplater=1 if ticker=="NBD." /* NORBORD INC, surviving ticker: NBDFF */
(14 real changes made)

. replace droplater=1 if ticker=="NII." /* NORSAT INTL INC, surviving ticker: 3NSATF */
(14 real changes made)

. replace droplater=1 if ticker=="NT." /* NORTEL NETWORKS CORP, surviving ticker: NT */
(14 real changes made)

. replace droplater=1 if ticker=="PDL" /* NORTH AMERICAN PALLADIUM, surviving ticker: PAL */
(14 real changes made)

. replace droplater=1 if ticker=="NDM" /* NORTHERN DYNASTY MINERAL LTD, surviving ticker: NAK */
(14 real changes made)

. replace droplater=1 if ticker=="NHD" /* NORTHERN HEMISPHERE DEV CP, surviving ticker: 3HSDME */
(14 real changes made)

. replace droplater=1 if ticker=="NNO." /* NORTHERN ORION RESOURCES INC, surviving ticker: NTO */
(14 real changes made)

. replace droplater=1 if ticker=="NGX." /* NORTHGATE MINERALS CORP, surviving ticker: NGX */
(14 real changes made)

. replace droplater=1 if ticker=="NCX." /* NOVA CHEMICALS CORP, surviving ticker: NCX */
(14 real changes made)

. replace droplater=1 if ticker=="NG." /* NOVAGOLD RESOURCES LTD, surviving ticker: NG */
(14 real changes made)

. replace droplater=1 if ticker=="3311B" /* NOVAMERICAN STEEL INC, surviving ticker: TONS */
(14 real changes made)

. replace droplater=1 if ticker=="NVL." /* NOVELIS INC, surviving ticker: NVL */
(14 real changes made)

. replace droplater=1 if ticker=="NCS." /* NUCRYST PHARM CORP -REDH, surviving ticker: NCST */
(14 real changes made)

. replace droplater=1 if ticker=="0115B" /* NYMOX PHARMACEUTICAL CORP, surviving ticker: NYMX */
(14 real changes made)

. replace droplater=1 if ticker=="3OFSYF" /* OFFSHORE SYSTEMS INTL LTD, surviving ticker: OSI. */
(14 real changes made)

. replace droplater=1 if ticker=="ONC" /* ONCOLYTICS BIOTECH INC, surviving ticker: ONCY */
(14 real changes made)

. replace droplater=1 if ticker=="OTC" /* OPEN TEXT CORP, surviving ticker: OTEX */
(14 real changes made)

. replace droplater=1 if ticker=="OPY.NV" /* OPPENHEIMER HLDGS INC  -CL A, surviving ticker: OPY */
(14 real changes made)

. replace droplater=1 if ticker=="2129B" /* OPTIMAL GROUP INC, surviving ticker: 2129B */
(14 real changes made)

. replace droplater=1 if ticker=="OZN." /* OREZONE RESOURCES INC, surviving ticker: OZN */
(14 real changes made)

. replace droplater=1 if ticker=="OTT.U" /* OTELCO INC, suviving ticker: OTT */
(14 real changes made)

. replace droplater=1 if ticker=="7598B" /* PLC SYSTEMS INC, surviving ticker: PLC */
(14 real changes made)

. replace droplater=1 if ticker=="PMU." /* PACIFIC RIM MINING CORP, surviving ticker: PMU */
(14 real changes made)

. replace droplater=1 if ticker=="PAA." /* PAN AMERICAN SILVER CORP, surviving ticker: PAAS */
(14 real changes made)

. replace droplater=1 if ticker=="PEI." /* PARLAY ENTERTAINMENT INC, surviving ticker: PRYNF */
(14 real changes made)

. replace droplater=1 if ticker=="PAE.LV"  /* PEACE ARCH ENTMT GROUP INC, surviving ticker: PAE */ 
(14 real changes made)

. replace droplater=1 if ticker=="PGF.A" /* PENGROWTH ENERGY TRUST, surviving ticker: PGH */
(14 real changes made)

. replace droplater=1 if ticker=="PCR." /* PERU COPPER INC, surviving ticker: CUP */
(14 real changes made)

. replace droplater=1 if ticker=="PTQ" /* PETAQUILLA MINERALS LTD, surviving ticker: 3PTQMF */
(14 real changes made)

. replace droplater=1 if ticker=="PCA." /* PETRO-CANADA, surviving ticker: PCZ */
(14 real changes made)

. replace droplater=1 if ticker=="PTF.U" /* PETROFUND ENERGY TRUST, surviving ticker: PFT */
(14 real changes made)

. replace droplater=1 if ticker=="PQU" /* PETROQUEST ENERGY INC, suviving ticker: PQ */
(14 real changes made)

. replace droplater=1 if ticker=="PDG." /* PLACER DOME INC, surviving ticker: PDG */
(14 real changes made)

. replace droplater=1 if ticker=="LAN." /* PLAINTREE SYSTEMS INC, surviving ticker: 3LANPF */
(14 real changes made)

. replace droplater=1 if ticker=="PPK." /* POLYAIR INTER PACK INC, surviving ticker: PPK */
(14 real changes made)

. replace droplater=1 if ticker=="PYM." /* POLYMER SOLUTIONS INC, surviving ticker: 3PYSU */
(14 real changes made)

. replace droplater=1 if ticker=="POM." /* POLYMET MINING CORP, surviving ticker: 3POMGF */
(14 real changes made)

. replace droplater=1 if ticker=="POT." /* POTASH CORP SASK INC, surviving ticker: POT */
(14 real changes made)

. replace droplater=1 if ticker=="PRP" /* PRAIRIE PACIFIC ENERGY CORP, surviving ticker: 3PRPEF */
(14 real changes made)

. replace droplater=1 if ticker=="PD.U" /* PRECISION DRILLING TRUST, surviving ticker: PDS */
(14 real changes made)

. replace droplater=1 if ticker=="PMD." /* PREMD INC, surviving ticker: PME */
(14 real changes made)

. replace droplater=1 if ticker=="PBI.U" /* PREMIUM BRANDS INCOME FUND, surviving ticker: PRMBF */
(14 real changes made)

. replace droplater=1 if ticker=="PWI.U" /* PRIMEWEST ENERGY TRUST, surviving ticker: PWI */
(14 real changes made)

. replace droplater=1 if ticker=="7050B" /* PRINCETON MEDIA GROUP INC, surviving ticker: PMGIF */
(14 real changes made)

. replace droplater=1 if ticker=="PVE.U" /* PROVIDENT ENERGY TRUST, surviving ticker: PVX */
(14 real changes made)

. replace droplater=1 if ticker=="QLT" /* QLT INC, surviving ticker: GLTI */
(14 real changes made)

. replace droplater=1 if ticker=="AAZ" /* QSOUND LABS INC, surviving ticker: QSND */
(14 real changes made)

. replace droplater=1 if ticker=="QZM" /* QUARTZ MOUNTAIN RESOURCES, surviving ticker: 3QZMRE */
(14 real changes made)

. replace droplater=1 if ticker=="QBR.SV.B" /* QUEBECOR INC  -CL B, surviving ticker: 3QBCRF */
(14 real changes made)

. replace droplater=1 if ticker=="IQW.SV" /* QUEBECOR WORLD INC  -SUB VTG, surviving ticker: IQW */
(14 real changes made)

. replace droplater=1 if ticker=="QRL" /* QUEENSTAKE RES LTD YUKON, surviving ticker: QEE */
(14 real changes made)

. replace droplater=1 if ticker=="QC" /* QUEST CAPITAL CORP, surviving ticker: QCC */
(14 real changes made)

. replace droplater=1 if ticker=="GHVRF" /* RED LAKE RESOURCES INC, surviving ticker: RL. */
(14 real changes made)

. replace droplater=1 if ticker=="RLO." /* REGALITO COPPER CORP, surviving ticker: RLO */
(14 real changes made)

. replace droplater=1 if ticker=="RGF." /* REPUBLIC GOLDFIELDS, surviving ticker: 3RPGDF */
(14 real changes made)

. replace droplater=1 if ticker=="RIM" /* RESEARCH IN MOTION LTD, surviving ticker: RIMM */
(14 real changes made)

. replace droplater=1 if ticker=="RPC." /* REVENUE PROPERTIES CO LTD, surviving ticker: RPCFF */
(14 real changes made)

. replace droplater=1 if ticker=="RIC." /* RICHMONT MINES INC, surviving ticker: RIC */
(14 real changes made)

. replace droplater=1 if ticker=="RNO" /* RIO NARCEA GOLD MINES LTD, surviving ticker: RNG */
(14 real changes made)

. replace droplater=1 if ticker=="RBA." /* RITCHIE BROS AUCTIONEERS INC, surviving ticker: RBS */
(14 real changes made)

. replace droplater=1 if ticker=="RTI." /* RIVAL TECHNOLOGIES INC, surviving ticker: 3RVTI */
(14 real changes made)

. replace droplater=1 if ticker=="RE." /* ROCK ENERGY INC, surviving ticker: RENFF */
(14 real changes made)

. replace droplater=1 if ticker=="RCI.NV.B" /* ROGERS COMMUNICATIONS  -CL B, surviving ticker: RG */
(14 real changes made)

. replace droplater=1 if ticker=="3591B" /* ROSEDALE DECORATIVE PROD LTD, surviving ticker: ROSD */
(14 real changes made)

. replace droplater=1 if ticker=="RYG." /* ROYAL GROUP TECHNOLOGIES LTD, surviving ticker: RYG */
(14 real changes made)

. replace droplater=1 if ticker=="ROY.U" /* ROYSTER-CLARK LTD, surviving ticker: 0912B */
(14 real changes made)

. replace droplater=1 if ticker=="RMX." /* RUBICON MINERALS CORP, surviving ticker: RBY */
(14 real changes made)

. replace droplater=1 if ticker=="RSM" /* ROYAL STANDARD MINERALS INC, surviving ticker: 3RYSMF */
(14 real changes made)

. replace droplater=1 if ticker=="RUS." /* RUSSEL METALS INC, surviving ticker: RUSMF */
(14 real changes made)

. replace droplater=1 if ticker=="SRXAF" /* S R TELECOM INC, surviving ticker: SRX. */
(14 real changes made)

. replace droplater=1 if ticker=="9022B" /* SCHMITT INDUSTRIES INC/OR, surviving ticker: SMIT */
(14 real changes made)

. replace droplater=1 if ticker=="SLP." /* SCINTILORE EXPLORATIONS LTD, surviving ticker: SLPFF */
(14 real changes made)

. replace droplater=1 if ticker=="SEA." /* SEABRIDGE GOLD INC, surviving ticker: SA */
(14 real changes made)

. replace droplater=1 if ticker=="3SNSG" /* 3SNSGSENSE TECHNOLOGIES INC, surviving ticker: SSE.Z */
(14 real changes made)

. replace droplater=1 if ticker=="SVN" /* 724 SOLUTIONS INC, surviving ticker: SVNX */
(14 real changes made)

. replace droplater=1 if ticker=="SJR" /* SHAW COMMUNICATIONS INC-CL B, surviving ticker: SJR.NV.B */
(14 real changes made)

. replace droplater=1 if ticker=="SHC." /* SHELL CANADA LTD  -CL A, surviving ticker: 3SCUAF */
(14 real changes made)

. replace droplater=1 if ticker=="0416B" /* SHEP TECHNOLOGIES INC, surviving ticker: STLOF */
(14 real changes made)

. replace droplater=1 if ticker=="SW." /* SIERRA WIRELESS INC, surviving ticker: SWIR */
(14 real changes made)

. replace droplater=1 if ticker=="SWE" /* SILENT WITNESS ENTERPRISES, surviving ticker: SILWF */
(14 real changes made)

. replace droplater=1 if ticker=="8710B" /* SILVERADO GOLD MINES LTD, surviving ticker: 3SLGLF */
(14 real changes made)

. replace droplater=1 if ticker=="SSO" /* SILVER STANDARD RES INC, surviving ticker: SSRI */
(14 real changes made)

. replace droplater=1 if ticker=="SLW" /* SILVER WHEATON CORP, surviving ticker: SLW. */
(14 real changes made)

. replace droplater=1 if ticker=="SOLI" /* SOLITARIO RESOURCES CORP, surviving ticker: SLR. */
(14 real changes made)

. replace droplater=1 if ticker=="SDI" /* SPECTRAL DIAGNOSTICS INC, surviving ticker: DIAGF */
(14 real changes made)

. replace droplater=1 if ticker=="SSY." /* SPECTRUM SIGNAL PROCESSING, surviving ticker: SSPI */
(14 real changes made)

. replace droplater=1 if ticker=="SXC" /* STANTEC INC, surviving ticker: STN. */
(14 real changes made)

. replace droplater=1 if ticker=="SLX" /* STELLAR PHARMACEUTICALS INC, surviving ticker: 3SLXCF */
(14 real changes made)

. replace droplater=1 if ticker=="SGD" /* STERLITE GOLD LTD, surviving ticker: SGDTF */
(14 real changes made)

. replace droplater=1 if ticker=="SME" /* STORM CAT ENERGY CORP, surviving ticker: SCU */
(14 real changes made)

. replace droplater=1 if ticker=="SLF." /* SUN LIFE FINANCIAL INC, surviving ticker: SLF */
(14 real changes made)

. replace droplater=1 if ticker=="SU." /* SUNCOR ENERGY INC, surviving ticker: SU */
(14 real changes made)

. replace droplater=1 if ticker=="SOY" /* SUNOPTA INC, surviving ticker: STKL */
(14 real changes made)

. replace droplater=1 if ticker=="TLC" /* TLC VISION CORP, surviving ticker: TLSV */
(14 real changes made)

. replace droplater=1 if ticker=="TLM." /* TALISMAN ENERGY INC, surviving ticker: TLM */
(14 real changes made)

. replace droplater=1 if ticker=="TNX" /* TAN RANGE EXPLORATION CP, surviving ticker: TRE */
(14 real changes made)

. replace droplater=1 if ticker=="TKO." /* TASEKO MINES LTD, surviving ticker: TGB */
(14 real changes made)

. replace droplater=1 if ticker=="TNC." /* TELESIS NORTH COMMUNICATIONS, surviving ticker: TNCVF */
(14 real changes made)

. replace droplater=1 if ticker=="TU" /* TELUS CORP, surviving ticker: T.NV */
(14 real changes made)

. replace droplater=1 if ticker=="TIW." /* TELESYSTEM INTL WIRELESS INC, surviving ticker: TIWIF */
(14 real changes made)

. replace droplater=1 if ticker=="TEO." /* TESCO CORP, surviving ticker: TESOF */
(14 real changes made)

. replace droplater=1 if ticker=="TOC." /* THOMSON CORP, surviving ticker: TOC */
(14 real changes made)

. replace droplater=1 if ticker=="0458B" /* TRANS ORIENT PETROLEUM LTD, surviving ticker: 3TOPLF */
(14 real changes made)

. replace droplater=1 if ticker=="TAC" /* TRANSALTA CORP, surviving ticker: TA: */
(14 real changes made)

. replace droplater=1 if ticker=="TRP." /* TRANSCANADA CORP, surviving ticker: TRP */
(14 real changes made)

. replace droplater=1 if ticker=="TGL." /* TRANSGLOBE ENERGY CORP, surviving ticker: TGA */
(14 real changes made)

. replace droplater=1 if ticker=="TRZ.1" /* TRIZEC PROPERTIES INC, surviving ticker: TRZ */
(14 real changes made)

. replace droplater=1 if ticker=="TDR." /* TUDOR CORP LTD, surviving ticker: TDRLF */
(14 real changes made)

. replace droplater=1 if ticker=="UP" /* ULTRA PETROLEUM CORP, surviving ticker: UPL */
(14 real changes made)

. replace droplater=1 if ticker=="UVI" /* UNILENS VISION INC, surviving ticker: 3UVICF */
(14 real changes made)

. replace droplater=1 if ticker=="VAS." /* VASOGEN INC, surviving ticker: VSGN */
(14 real changes made)

. replace droplater=1 if ticker=="VIR." /* VIREXX MEDICAL CORP, surviving ticker: REX */
(14 real changes made)

. replace droplater=1 if ticker=="VGZ." /* VIREXX MEDICAL CORPVISTA GOLD CORP, surviving ticker: VGZ */
(14 real changes made)

. replace droplater=1 if ticker=="3VISRF" /* VISIPHOR CORP, surviving ticker: VIS. */
(14 real changes made)

. replace droplater=1 if ticker=="VTN." /* VITRAN CORP INC, surviving ticker: VTNC */
(14 real changes made)

. replace droplater=1 if ticker=="WCS.SV.A" /* WESCAST INDUSTRIES  -CL A, surviving ticker: WCSTF */
(14 real changes made)

. replace droplater=1 if ticker=="WED" /* WESTAIM CORP, surviving ticker: WEDX */
(14 real changes made)

. replace droplater=1 if ticker=="WTZ" /* WESTERN SILVER CORP, surviving ticker: WTC */
(14 real changes made)

. replace droplater=1 if ticker=="9354B" /* WIDECOM GROUP INC, surviving ticker: WIDE */
(14 real changes made)

. replace droplater=1 if ticker=="WHT." /* WORLD HEART CORP, surviving ticker: WHRT */
(14 real changes made)

. replace droplater=1 if ticker=="YM" /* YM BIOSCIENCES INC, surviving ticker: YMI */
(14 real changes made)

. replace droplater=1 if ticker=="YRI" /* YAMANA GOLD INC, surviving ticker: AUY */
(14 real changes made)

. replace droplater=1 if ticker=="ZIC" /* ZI CORP, surviving ticker: ZICA */
(14 real changes made)

. replace droplater=1 if ticker=="ZL." /* ZARLINK SEMICONDUCTOR INC, surviving ticker: ZL */
(14 real changes made)

. replace droplater=1 if ticker=="8115B" /* ZOOM TECHNOLOGIES INC, surviving ticker: ZOOM */
(14 real changes made)

. replace droplater=1 if ticker=="ZTE" /* ZTEST ELECTRONICS INC, surviving ticker: ZTSTF */
(14 real changes made)

. replace droplater=1 if ticker=="POC.SV.B" /* PAN-OCEAN ENERGY CORP -CL B, surviving ticker: PNYBF */
(14 real changes made)

. replace droplater=1 if ticker=="SVS.U" /* SEVEN SEAS PETROLEUM INC, surviving ticker: 3SVSSF */
(14 real changes made)

. 
. *additional drops, which became nessessary, caused by the merge of comp and segm.
. * surviving ticker are in the segment data set.
. 
. replace droplater=1 if ticker=="AFM.1" /* AMERICAN RADIO SYS CP  -CL A, surviving ticker: AFM.2 */
(14 real changes made)

. replace droplater=1 if ticker=="AREN" /* ARGOSY ENERGY INC, surviving ticker: AREN. */
(14 real changes made)

. replace droplater=1 if ticker=="BOSS" /* BUILDING ONE SVCS CORP, surviving ticker: BOSS.1 */
(14 real changes made)

. replace droplater=1 if ticker=="3CCSE" /*COMMUNITY CARE SVCS INC, 3CCSE. */
(14 real changes made)

. replace droplater=1 if ticker=="CMPS" /*COMPASS INTL SVCS CORP,surviving ticker: CMPS.1*/
(14 real changes made)

. replace droplater=1 if ticker=="DLGC" /* DIALOGIC CORP ,surviving ticker: DLGC.1*/
(14 real changes made)

. replace droplater=1 if ticker=="3FSNR" /*FRANKLIN SELECT RLTY   -CL A,surviving ticker: 3FSNR.*/
(14 real changes made)

. replace droplater=1 if ticker=="SCHA" /*SMART CHOICE AUTO GRP,surviving ticker: SCHA.1*/
(14 real changes made)

. replace droplater=1 if ticker=="3WSDIE" /* WALL ST DELI INC ,surviving ticker: WSDI*/
(14 real changes made)

. 
. 
. drop if droplater==1
(5054 observations deleted)

. drop droplater

. desc

Contains data from raw data/master_compustat_all_countries.dta
  obs:       335,776                          
 vars:            71                          16 Jan 2008 10:57
 size:   162,851,360                          
------------------------------------------------------------------------------------------------------------------------------------------
              storage   display    value
variable name   type    format     label      variable label
------------------------------------------------------------------------------------------------------------------------------------------
ticker          str8    %9s                   Ticker Symbol
year            int     %10.0g                calender year
CUSIP           str9    %9s                   CUSIP number
name            str28   %28s                  Company Name
sales           double  %10.0g                Sales in millions of dollars
employees       double  %10.0g                number of Employees in thousands
vantagekey      long    %12.0g                Global Vantage key
countryinc      byte    %10.0g                Country of Incorporation
v13             long    %12.0g                
costsales       double  %10.0g                Cost of goods sold in millions of dollars
ebitda          double  %10.0g                Operating Income Before Depreciation in millions of dollars
ebitda_m        double  %10.0g                EBITDA Margin (percentage points)
ebit            double  %10.0g                Operating Income After Depreciation in millions of dollars
ebit_m          double  %10.0g                EBIT Margin (percentage points)
roi             double  %10.0g                Return on Investment (percentage points)
roe             double  %10.0g                Return on Equity (percentage points)
roa             double  %10.0g                Return on Assets (percentage points)
price_book      double  %10.0g                Price to Book ratio (Market Value - Monthly divided by Quarterly Common Equity -
eps_basic       double  %10.0g                EPS Basic Exc Extra Items in dollars and cents
eps_diluted     double  %10.0g                EPS Diluted Exc Extra Items in dollars and cents
eps_operate     double  %10.0g                EPS from Operations-12MM in dollars
debt_mv         double  %10.0g                Debt to Market Value (share)
debt_ebitda     double  %10.0g                Debt to EBITDA (share)
np_margin       double  %10.0g                Net Profit Margin (percentage points)
intangibles     double  %10.0g                Intangibles in millions of dollars
tca             double  %10.0g                Total Current Assets in millions of dollars
ta              double  %10.0g                Tatal Assets in millions of dollars
SICALL2         int     %10.0g                SICALL2
SICALL3         int     %10.0g                SICALL3
SICALL4         int     %10.0g                SICALL4
SICALL5         int     %10.0g                SICALL5
SICALL6         int     %10.0g                SICALL6
SICALL7         int     %10.0g                SICALL7
SICALL8         int     %10.0g                SICALL8
SICALL9         int     %10.0g                SICALL9
SICALL10        int     %10.0g                SICALL10
SICALL11        int     %10.0g                SICALL11
SICALL12        int     %10.0g                SICALL12
SICALL13        int     %10.0g                SICALL13
SICALL14        int     %10.0g                SICALL14
SICALL15        int     %10.0g                SICALL15
comshare        double  %10.0g                Common shares outstanding in millions
ltd             double  %10.0g                Long term dept in millions of dollars
dep             double  %10.0g                Depreciation and amortization in millions of dollars
depttot         double  %10.0g                Dept - total in millions of dollars
div             double  %10.0g                Cash dividends in millions of dollars
divpref         double  %10.0g                Cash dividends preferred in millions of dollars
capexp          double  %10.0g                Capital Expenditures in millions of dollars
incomebef       double  %10.0g                Income before extra items in millions of dollars
liab            double  %10.0g                Current liabilites - total in millions of dollars
netinc          double  %10.0g                Net income (loss) in millions of dollars
property        double  %10.0g                Property, plant, and eqipment in millions of dollars
price_close     double  %10.0g                Price - close calendar year in dollars and cents
price_high      double  %10.0g                Price - high calendar year in dollars and cents
price_low       double  %10.0g                Price - low calendar year in dollars and cents
prefstock       double  %10.0g                Preferred stock in millions of dollars
prefstock_c     double  %10.0g                Preferred stock convertable in millions of dollars
rdproc          double  %10.0g                R&D in process (portion)
forn_sales      double  %10.0g                Total foreign sales
incometax       double  %10.0g                Income taxes - total in millions of dollars
interestexp     double  %10.0g                Interest expense in millions of dollars
laborexp        double  %10.0g                Labor and related expense in millions of dollars
pensionexp      double  %10.0g                Pension and retirement expense in millions of dollars
bankrupt        double  %10.0g                Measure of bankruptcy
state_abrv      str15   %15s                  Adress - state
SIC4            int     %8.0g                 primary sic code
rdexpense       double  %10.0g                R&D expense in millions of dollars
mkvalf          double  %10.0g                
mkval           double  %10.0g                
mkvalm          double  %10.0g                
mkvalq          double  %10.0g                
------------------------------------------------------------------------------------------------------------------------------------------
Sorted by:  CUSIP  year
     Note:  dataset has changed since last saved

. 
. save "clean_compustat_master.dta", replace
file clean_compustat_master.dta saved

. 
. log close
      name:  <unnamed>
       log:  E:\REStat_MS14767_Vol96(2)\Data preparation Compustat segment\1_cleancompustat.log
  log type:  text
 closed on:  18 Dec 2014, 18:04:48
------------------------------------------------------------------------------------------------------------------------------------------
